Overview

Dataset info

Number of variables57
Number of observations33707
Missing cells1 (< 0.1%)
Duplicate rows0 (0.0%)
Total size in memory113.6 MiB
Average record size in memory3.5 KiB

Variables types

CAT48
NUM5
BOOL4

Reproduction info

Date of analysis2020-02-19 02:56:57.625294
Versionpandas-profiling v2.4.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download Configurationconfig.yaml

Warnings

City has a high cardinality: 444 distinct values Warning
County has a high cardinality: 100 distinct values Warning
CrashHour has 716 (2.1%) zeros Zeros
CrashType has a high cardinality: 56 distinct values Warning
DrvrAge has a high cardinality: 99 distinct values Warning
geo_point_2d has a high cardinality: 33627 distinct values Warning
PedAge has a high cardinality: 102 distinct values Warning
CrashType is highly correlated with CrashGrpHigh Correlation
CrashGrp is highly correlated with CrashTypeHigh Correlation
DrvrAgeGrp is highly correlated with DrvrAgeHigh Correlation
DrvrAge is highly correlated with DrvrAgeGrpHigh Correlation
DrvrAlcFlg is highly correlated with DrvrAlcDrgHigh Correlation
DrvrAlcDrg is highly correlated with DrvrAlcFlgHigh Correlation
PedAlcDrg is highly correlated with Ped_Intox.High Correlation
Ped_Intox. is highly correlated with PedAlcDrgHigh Correlation
Region is highly correlated with CountyHigh Correlation
County is highly correlated with RegionHigh Correlation

Variables

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
No
28957
Yes
 
4750
ValueCountFrequency (%) 
No 28957 85.9%
 
Yes 4750 14.1%
 

Ambulance
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Yes
24223
No
9484
ValueCountFrequency (%) 
Yes 24223 71.9%
 
No 9484 28.1%
 

City
Categorical

HIGH CARDINALITY
Distinct count444
Unique (%)1.3%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
None - Rural Crash
6680
Charlotte
5325
Raleigh
 
2584
Greensboro
 
1823
Durham
 
1630
Other values (439)
15665
ValueCountFrequency (%) 
None - Rural Crash 6680 19.8%
 
Charlotte 5325 15.8%
 
Raleigh 2584 7.7%
 
Greensboro 1823 5.4%
 
Durham 1630 4.8%
 
Fayetteville 1188 3.5%
 
Asheville 851 2.5%
 
Winston-Salem 850 2.5%
 
Wilmington 768 2.3%
 
High Point 513 1.5%
 
Other values (434) 11495 34.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length22
Mean length10.77179814
Min length4
Scatter

County
Categorical

HIGH CARDINALITY
HIGH CORRELATION
Distinct count100
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Mecklenburg
5777
Wake
 
3647
Guilford
 
2527
Durham
 
1690
Cumberland
 
1517
Other values (95)
18549
ValueCountFrequency (%) 
Mecklenburg 5777 17.1%
 
Wake 3647 10.8%
 
Guilford 2527 7.5%
 
Durham 1690 5.0%
 
Cumberland 1517 4.5%
 
Forsyth 1125 3.3%
 
Buncombe 1102 3.3%
 
New Hanover 1035 3.1%
 
Gaston 827 2.5%
 
Pitt 577 1.7%
 
Other values (90) 13883 41.2%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length12
Mean length7.552911858
Min length3
Scatter

CrashGrp
Categorical

HIGH CORRELATION
Distinct count16
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Unusual Circumstances
6097
Crossing Roadway—Vehicle Not Turning
5320
Off Roadway
4365
Walking Along Roadway
3779
Backing Vehicle
3567
Other values (11)
10579
ValueCountFrequency (%) 
Unusual Circumstances 6097 18.1%
 
Crossing Roadway—Vehicle Not Turning 5320 15.8%
 
Off Roadway 4365 12.9%
 
Walking Along Roadway 3779 11.2%
 
Backing Vehicle 3567 10.6%
 
Crossing Roadway—Vehicle Turning 3437 10.2%
 
Dash/Dart-Out 2475 7.3%
 
Pedestrian in Roadway—Circumstances Unknown 1856 5.5%
 
Crossing Driveway or Alley 614 1.8%
 
Other/Unknown—Insufficient Details 554 1.6%
 
Other values (6) 1643 4.9%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length43
Mean length23.50158721
Min length11
Scatter

CrashHour
Real number (ℝ≥0)

ZEROS
Distinct count24
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.17833091
Minimum0
Maximum23
Zeros716
Zeros (%)2.1%
Memory size263.4 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile2
Q110
median15
Q319
95-th percentile22
Maximum23
Range23
Interquartile range (IQR)9

Descriptive statistics

Standard deviation5.933898459
Coefficient of variation (CV)0.4185188296
Kurtosis-0.4161920115
Mean14.17833091
Median Absolute Deviation (MAD)4.883747282
Skewness-0.631944478
Sum477909
Variance35.21115092
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 2.5 5.5 6.5 ... 16.5 19.5 21.5 22.5 23. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
18 2552 7.6%
 
17 2448 7.3%
 
19 2347 7.0%
 
20 2203 6.5%
 
15 2142 6.4%
 
21 2129 6.3%
 
16 2070 6.1%
 
14 1849 5.5%
 
13 1680 5.0%
 
12 1656 4.9%
 
Other values (14) 12631 37.5%
 
ValueCountFrequency (%) 
0 716 2.1%
 
1 629 1.9%
 
2 719 2.1%
 
3 406 1.2%
 
4 324 1.0%
 
ValueCountFrequency (%) 
23 1061 3.1%
 
22 1546 4.6%
 
21 2129 6.3%
 
20 2203 6.5%
 
19 2347 7.0%
 

CrashLoc
Categorical

Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Non-Intersection
14479
Non-Roadway
9971
Intersection
6134
Intersection-Related
3077
Unknown
 
46
ValueCountFrequency (%) 
Non-Intersection 14479 43.0%
 
Non-Roadway 9971 29.6%
 
Intersection 6134 18.2%
 
Intersection-Related 3077 9.1%
 
Unknown 46 0.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length20
Mean length14.14587474
Min length7
Scatter

CrashMonth
Categorical

Distinct count12
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
October
 
3575
November
 
3318
December
 
3164
September
 
3005
August
 
2727
Other values (7)
17918
ValueCountFrequency (%) 
October 3575 10.6%
 
November 3318 9.8%
 
December 3164 9.4%
 
September 3005 8.9%
 
August 2727 8.1%
 
May 2668 7.9%
 
March 2654 7.9%
 
April 2632 7.8%
 
January 2608 7.7%
 
June 2469 7.3%
 
Other values (2) 4887 14.5%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length9
Mean length6.295012905
Min length3
Scatter

CrashSevr
Categorical

Distinct count6
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
C: Possible Injury
13802
B: Suspected Minor Injury
12100
O: No Injury
2781
A: Suspected Serious Injury
 
2474
K: Killed
 
2188
ValueCountFrequency (%) 
C: Possible Injury 13802 40.9%
 
B: Suspected Minor Injury 12100 35.9%
 
O: No Injury 2781 8.3%
 
A: Suspected Serious Injury 2474 7.3%
 
K: Killed 2188 6.5%
 
Unknown Injury 362 1.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length27
Mean length20.05120598
Min length9
Scatter

CrashType
Categorical

HIGH CARDINALITY
HIGH CORRELATION
Distinct count56
Unique (%)0.2%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Pedestrian Failed to Yield
4563
Off Roadway - Parking Lot
3645
Walking Along Roadway With Traffic - From Behind
 
2722
Backing Vehicle - Parking Lot
 
2592
Motorist Left Turn - Parallel Paths
 
2009
Other values (51)
18176
ValueCountFrequency (%) 
Pedestrian Failed to Yield 4563 13.5%
 
Off Roadway - Parking Lot 3645 10.8%
 
Walking Along Roadway With Traffic - From Behind 2722 8.1%
 
Backing Vehicle - Parking Lot 2592 7.7%
 
Motorist Left Turn - Parallel Paths 2009 6.0%
 
Dash 2002 5.9%
 
Vehicle-Vehicle / Object 1129 3.3%
 
Motor Vehicle Loss of Control 1103 3.3%
 
Walking in Roadway 910 2.7%
 
Dispute-Related 892 2.6%
 
Other values (46) 12140 36.0%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length52
Mean length27.18177233
Min length4
Scatter

CrashYear
Real number (ℝ≥0)

Distinct count12
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2012.87602
Minimum2007
Maximum2018
Zeros0
Zeros (%)0.0%
Memory size263.4 KiB
Mini histogram

Quantile statistics

Minimum2007
5-th percentile2007
Q12010
median2013
Q32016
95-th percentile2018
Maximum2018
Range11
Interquartile range (IQR)6

Descriptive statistics

Standard deviation3.458473963
Coefficient of variation (CV)0.001718175352
Kurtosis-1.187906126
Mean2012.87602
Median Absolute Deviation (MAD)2.987231755
Skewness-0.1478144669
Sum67848012
Variance11.96104215
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[2007. 2007.5 2011.5 2012.5 2013.5 2017.5 2018. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2018 3390 10.1%
 
2016 3190 9.5%
 
2017 3113 9.2%
 
2015 3050 9.0%
 
2014 2986 8.9%
 
2012 2970 8.8%
 
2013 2720 8.1%
 
2007 2548 7.6%
 
2010 2545 7.6%
 
2009 2419 7.2%
 
Other values (2) 4776 14.2%
 
ValueCountFrequency (%) 
2007 2548 7.6%
 
2008 2372 7.0%
 
2009 2419 7.2%
 
2010 2545 7.6%
 
2011 2404 7.1%
 
ValueCountFrequency (%) 
2018 3390 10.1%
 
2017 3113 9.2%
 
2016 3190 9.5%
 
2015 3050 9.0%
 
2014 2986 8.9%
 

Day_of_Week
Categorical

Distinct count8
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Friday
5601
Thursday
5029
Wednesday
4984
Tuesday
4936
Saturday
4888
Other values (3)
8269
ValueCountFrequency (%) 
Friday 5601 16.6%
 
Thursday 5029 14.9%
 
Wednesday 4984 14.8%
 
Tuesday 4936 14.6%
 
Saturday 4888 14.5%
 
Monday 4742 14.1%
 
Sunday 3526 10.5%
 
. 1 < 0.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length9
Mean length7.178301243
Min length1
Scatter

Development
Categorical

Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Commercial
17268
Residential
11771
Farms, Woods, Pastures
 
3352
Institutional
 
1123
Industrial
 
193
ValueCountFrequency (%) 
Commercial 17268 51.2%
 
Residential 11771 34.9%
 
Farms, Woods, Pastures 3352 9.9%
 
Institutional 1123 3.3%
 
Industrial 193 0.6%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length22
Mean length11.64250749
Min length10
Scatter

DrvrAge
Categorical

HIGH CARDINALITY
HIGH CORRELATION
Distinct count99
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
999
6078
21
 
721
20
 
716
22
 
702
19
 
670
Other values (94)
24820
ValueCountFrequency (%) 
999 6078 18.0%
 
21 721 2.1%
 
20 716 2.1%
 
22 702 2.1%
 
19 670 2.0%
 
24 666 2.0%
 
23 662 2.0%
 
25 656 1.9%
 
26 624 1.9%
 
27 621 1.8%
 
Other values (89) 21591 64.1%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length2.193550301
Min length1
Scatter

DrvrAgeGrp
Categorical

HIGH CORRELATION
Distinct count9
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Unknown
6078
30-39
4910
40-49
4497
50-59
4123
20-24
3467
Other values (4)
10632
ValueCountFrequency (%) 
Unknown 6078 18.0%
 
30-39 4910 14.6%
 
40-49 4497 13.3%
 
50-59 4123 12.2%
 
20-24 3467 10.3%
 
60-69 3033 9.0%
 
25-29 3033 9.0%
 
70+ 2451 7.3%
 
0-19 2115 6.3%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length7
Mean length5.152460913
Min length3
Scatter

DrvrAlcDrg
Categorical

HIGH CORRELATION
Distinct count10
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
No
19826
.
7339
Missing
 
3778
Unknown
 
1810
Yes-Alcohol, impairment suspected
 
647
Other values (5)
 
307
ValueCountFrequency (%) 
No 19826 58.8%
 
. 7339 21.8%
 
Missing 3778 11.2%
 
Unknown 1810 5.4%
 
Yes-Alcohol, impairment suspected 647 1.9%
 
Yes-Alcohol, impairment detected 114 0.3%
 
Yes-Drugs, impairment suspected 90 0.3%
 
Yes-Alcohol and Drugs, impairment suspected 74 0.2%
 
Yes-Drugs, impairment detected 18 0.1%
 
Yes-Alcohol and Drugs, impairment detected 11 < 0.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length43
Mean length3.503129914
Min length1
Scatter

DrvrAlcFlg
Categorical

HIGH CORRELATION
Distinct count4
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
No
25901
Missing
 
4863
Unknown
 
1810
Yes
 
1133
ValueCountFrequency (%) 
No 25901 76.8%
 
Missing 4863 14.4%
 
Unknown 1810 5.4%
 
Yes 1133 3.4%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length7
Mean length3.023466936
Min length2
Scatter

DrvrInjury
Categorical

Distinct count6
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
O: No Injury
25831
Unknown Injury
6554
C: Possible Injury
 
875
B: Suspected Minor Injury
 
402
A: Suspected Serious Injury
 
32
ValueCountFrequency (%) 
O: No Injury 25831 76.6%
 
Unknown Injury 6554 19.4%
 
C: Possible Injury 875 2.6%
 
B: Suspected Minor Injury 402 1.2%
 
A: Suspected Serious Injury 32 0.1%
 
K: Killed 13 < 0.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length27
Mean length12.71275996
Min length9
Scatter

DrvrRace
Categorical

Distinct count7
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
White
15814
Black
9446
Unknown/Missing
6019
Hispanic
 
1366
Other
 
437
Other values (2)
 
625
ValueCountFrequency (%) 
White 15814 46.9%
 
Black 9446 28.0%
 
Unknown/Missing 6019 17.9%
 
Hispanic 1366 4.1%
 
Other 437 1.3%
 
Asian 359 1.1%
 
Native American 266 0.8%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length15
Mean length6.986174978
Min length5
Scatter

DrvrSex
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Male
15605
Female
12181
Unknown
5921
ValueCountFrequency (%) 
Male 15605 46.3%
 
Female 12181 36.1%
 
Unknown 5921 17.6%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length7
Mean length5.24974041
Min length4
Scatter

DrvrVehTyp
Categorical

Distinct count30
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Passenger Car
16731
Sport Utility
5703
Pickup
4201
Unknown
3585
Van
 
1764
Other values (25)
 
1723
ValueCountFrequency (%) 
Passenger Car 16731 49.6%
 
Sport Utility 5703 16.9%
 
Pickup 4201 12.5%
 
Unknown 3585 10.6%
 
Van 1764 5.2%
 
Light Truck (Mini-Van, Panel) 496 1.5%
 
Single Unit Truck (2-Axle, 6-Tire) 253 0.8%
 
Tractor/Semi-Trailer 173 0.5%
 
Motorcycle 122 0.4%
 
Police 115 0.3%
 
Other values (20) 564 1.7%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length36
Mean length11.41486931
Min length3
Scatter

geo_point_2d
Categorical

HIGH CARDINALITY
Distinct count33627
Unique (%)99.8%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
35.7867199997,-78.6642000003
 
4
35.2171800003,-80.7919280006
 
3
35.9429080004,-78.6433279998
 
3
35.2162109998,-80.883695
 
3
35.052664,-78.8783580004
 
3
Other values (33622)
33691
ValueCountFrequency (%) 
35.7867199997,-78.6642000003 4 < 0.1%
 
35.2171800003,-80.7919280006 3 < 0.1%
 
35.9429080004,-78.6433279998 3 < 0.1%
 
35.2162109998,-80.883695 3 < 0.1%
 
35.052664,-78.8783580004 3 < 0.1%
 
35.6930199996,-79.7892549996 3 < 0.1%
 
35.9940319999,-78.898619 3 < 0.1%
 
35.2704769999,-80.8552800005 2 < 0.1%
 
35.2394429997,-80.8267530002 2 < 0.1%
 
35.2373310001,-80.8294490001 2 < 0.1%
 
Other values (33617) 33679 99.9%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length28
Mean length27.4883852
Min length15
Scatter

HitRun
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
No
26948
Yes
6759
ValueCountFrequency (%) 
No 26948 79.9%
 
Yes 6759 20.1%
 

Latitude
Real number (ℝ≥0)

Distinct count33417
Unique (%)99.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.51335494
Minimum33.87111238
Maximum36.56055562
Zeros0
Zeros (%)0.0%
Memory size263.4 KiB
Mini histogram

Quantile statistics

Minimum33.87111238
5-th percentile34.55187729
Q135.21120318
median35.57766089
Q335.92159953
95-th percentile36.19725146
Maximum36.56055562
Range2.68944324
Interquartile range (IQR)0.710396355

Descriptive statistics

Standard deviation0.5102914937
Coefficient of variation (CV)0.01436900272
Kurtosis0.2183930627
Mean35.51335494
Median Absolute Deviation (MAD)0.4187518569
Skewness-0.5996486238
Sum1197048.655
Variance0.2603974086
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[33.87111238 33.88509849 33.98465377 34.13402723 34.14907831 ... 36.34113158 36.38028148 36.5163685 36.53750502 36.56055562], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
35.78672 5 < 0.1%
 
35.22624 3 < 0.1%
 
35.22399 3 < 0.1%
 
35.79973 3 < 0.1%
 
35.052664 3 < 0.1%
 
35.21718 3 < 0.1%
 
35.05393 3 < 0.1%
 
35.22629 3 < 0.1%
 
35.69302 3 < 0.1%
 
35.216211 3 < 0.1%
 
Other values (33407) 33675 99.9%
 
ValueCountFrequency (%) 
33.87111238 1 < 0.1%
 
33.88089851 1 < 0.1%
 
33.88405 1 < 0.1%
 
33.88614698 1 < 0.1%
 
33.88668183 1 < 0.1%
 
ValueCountFrequency (%) 
36.56055562 1 < 0.1%
 
36.55046446 1 < 0.1%
 
36.55007256 1 < 0.1%
 
36.54868441 1 < 0.1%
 
36.54643648 1 < 0.1%
 

LightCond
Categorical

Distinct count8
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Daylight
18727
Dark - Lighted Roadway
7479
Dark - Roadway Not Lighted
5742
Dusk
 
936
Dawn
 
506
Other values (3)
 
317
ValueCountFrequency (%) 
Daylight 18727 55.6%
 
Dark - Lighted Roadway 7479 22.2%
 
Dark - Roadway Not Lighted 5742 17.0%
 
Dusk 936 2.8%
 
Dawn 506 1.5%
 
Dark - Unknown Lighting 202 0.6%
 
Unknown 67 0.2%
 
Other 48 0.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length26
Mean length14.08517519
Min length4
Scatter

Locality
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Urban (>70% Developed)
24541
Mixed (30% To 70% Developed)
 
4749
Rural (<30% Developed)
 
4417
ValueCountFrequency (%) 
Urban (>70% Developed) 24541 72.8%
 
Mixed (30% To 70% Developed) 4749 14.1%
 
Rural (<30% Developed) 4417 13.1%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length28
Mean length22.8453437
Min length22
Scatter

Longitude
Real number (ℝ)

Distinct count32538
Unique (%)96.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-79.67738988
Minimum-84.30409764
Maximum-75.46531744
Zeros0
Zeros (%)0.0%
Memory size263.4 KiB
Mini histogram

Quantile statistics

Minimum-84.30409764
5-th percentile-82.4495739
Q1-80.818937
median-79.77320325
Q3-78.64184636
95-th percentile-77.3946
Maximum-75.46531744
Range8.8387802
Interquartile range (IQR)2.177090635

Descriptive statistics

Standard deviation1.455286706
Coefficient of variation (CV)-0.01826473869
Kurtosis-0.40387766
Mean-79.67738988
Median Absolute Deviation (MAD)1.227280237
Skewness-0.06669284676
Sum-2685685.781
Variance2.117859395
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[-84.30409764 -84.11150091 -83.8268281 -83.79944954 -83.46063801 ... -76.25018063 -76.21071879 -75.72365164 -75.61576496 -75.46531744], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-80.843126 14 < 0.1%
 
-80.842 11 < 0.1%
 
-78.638614 8 < 0.1%
 
-80.8431 5 < 0.1%
 
-78.8948 5 < 0.1%
 
-78.6144 5 < 0.1%
 
-80.8764 5 < 0.1%
 
-80.8441 5 < 0.1%
 
-78.6473 5 < 0.1%
 
-80.8363 4 < 0.1%
 
Other values (32528) 33640 99.8%
 
ValueCountFrequency (%) 
-84.30409764 1 < 0.1%
 
-84.14253 1 < 0.1%
 
-84.12117546 1 < 0.1%
 
-84.10182636 1 < 0.1%
 
-84.10110982 1 < 0.1%
 
ValueCountFrequency (%) 
-75.46531744 1 < 0.1%
 
-75.46595076 1 < 0.1%
 
-75.4671 1 < 0.1%
 
-75.4682 1 < 0.1%
 
-75.46888114 1 < 0.1%
 

NumLanes
Categorical

Distinct count10
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
2 lanes
15612
Unknown
6560
4 lanes
4220
5 lanes
 
2316
3 lanes
 
1794
Other values (5)
3205
ValueCountFrequency (%) 
2 lanes 15612 46.3%
 
Unknown 6560 19.5%
 
4 lanes 4220 12.5%
 
5 lanes 2316 6.9%
 
3 lanes 1794 5.3%
 
1 lane 1528 4.5%
 
6 lanes 934 2.8%
 
7 lanes 317 0.9%
 
8 lanes 265 0.8%
 
9 or more lanes 161 0.5%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length15
Mean length6.992879817
Min length6
Scatter

NumPedsAin
Categorical

Distinct count6
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
.
17978
0
14494
1
 
1209
2
 
24
3
 
1
ValueCountFrequency (%) 
. 17978 53.3%
 
0 14494 43.0%
 
1 1209 3.6%
 
2 24 0.1%
 
3 1 < 0.1%
 
7 1 < 0.1%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length1
Mean length1
Min length1
Scatter

NumPedsBin
Categorical

Distinct count9
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
.
17976
0
10151
1
5429
2
 
126
3
 
16
Other values (4)
 
9
ValueCountFrequency (%) 
. 17976 53.3%
 
0 10151 30.1%
 
1 5429 16.1%
 
2 126 0.4%
 
3 16 < 0.1%
 
5 4 < 0.1%
 
4 3 < 0.1%
 
7 1 < 0.1%
 
12 1 < 0.1%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length2
Mean length1.000029667
Min length1
Scatter

NumPedsCin
Categorical

Distinct count7
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
.
17978
0
9205
1
6311
2
 
189
3
 
18
Other values (2)
 
6
ValueCountFrequency (%) 
. 17978 53.3%
 
0 9205 27.3%
 
1 6311 18.7%
 
2 189 0.6%
 
3 18 0.1%
 
4 5 < 0.1%
 
8 1 < 0.1%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length1
Mean length1
Min length1
Scatter

NumPedsKil
Categorical

Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
.
17978
0
14712
1
 
1005
2
 
11
4
 
1
ValueCountFrequency (%) 
. 17978 53.3%
 
0 14712 43.6%
 
1 1005 3.0%
 
2 11 < 0.1%
 
4 1 < 0.1%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length1
Mean length1
Min length1
Scatter

NumPedsNoi
Categorical

Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
.
17978
0
14697
1
 
989
2
 
39
3
 
4
ValueCountFrequency (%) 
. 17978 53.3%
 
0 14697 43.6%
 
1 989 2.9%
 
2 39 0.1%
 
3 4 < 0.1%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length1
Mean length1
Min length1
Scatter

NumPedsTot
Categorical

Distinct count10
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
.
17976
1
15033
2
 
588
3
 
82
4
 
12
Other values (5)
 
16
ValueCountFrequency (%) 
. 17976 53.3%
 
1 15033 44.6%
 
2 588 1.7%
 
3 82 0.2%
 
4 12 < 0.1%
 
5 7 < 0.1%
 
6 4 < 0.1%
 
7 3 < 0.1%
 
8 1 < 0.1%
 
20 1 < 0.1%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length2
Mean length1.000029667
Min length1
Scatter

NumPedsUin
Categorical

Distinct count6
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
.
17978
0
15067
1
 
646
2
 
13
3
 
2
ValueCountFrequency (%) 
. 17978 53.3%
 
0 15067 44.7%
 
1 646 1.9%
 
2 13 < 0.1%
 
3 2 < 0.1%
 
5 1 < 0.1%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length1
Mean length1
Min length1
Scatter

NumUnits
Real number (ℝ≥0)

Distinct count13
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.161242472
Minimum1
Maximum21
Zeros0
Zeros (%)0.0%
Memory size263.4 KiB
Mini histogram

Quantile statistics

Minimum1
5-th percentile2
Q12
median2
Q32
95-th percentile3
Maximum21
Range20
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.5354198308
Coefficient of variation (CV)0.2477370484
Kurtosis87.83084053
Mean2.161242472
Median Absolute Deviation (MAD)0.2844090252
Skewness6.313150678
Sum72849
Variance0.2866743952
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 5.5 6.5 8.5 10.5 21. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2 29720 88.2%
 
3 3055 9.1%
 
4 653 1.9%
 
5 160 0.5%
 
6 68 0.2%
 
7 19 0.1%
 
8 16 < 0.1%
 
9 6 < 0.1%
 
10 4 < 0.1%
 
12 3 < 0.1%
 
Other values (3) 3 < 0.1%
 
ValueCountFrequency (%) 
1 1 < 0.1%
 
2 29720 88.2%
 
3 3055 9.1%
 
4 653 1.9%
 
5 160 0.5%
 
ValueCountFrequency (%) 
21 1 < 0.1%
 
12 3 < 0.1%
 
11 1 < 0.1%
 
10 4 < 0.1%
 
9 6 < 0.1%
 

Ped_Intox.
Categorical

HIGH CORRELATION
Distinct count4
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
No
28120
Yes
 
3863
Unknown
 
1628
Missing
 
96
ValueCountFrequency (%) 
No 28120 83.4%
 
Yes 3863 11.5%
 
Unknown 1628 4.8%
 
Missing 96 0.3%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length7
Mean length2.370338505
Min length2
Scatter

PedAge
Categorical

HIGH CARDINALITY
Distinct count102
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
19
 
837
21
 
829
20
 
819
22
 
799
18
 
765
Other values (97)
29658
ValueCountFrequency (%) 
19 837 2.5%
 
21 829 2.5%
 
20 819 2.4%
 
22 799 2.4%
 
18 765 2.3%
 
23 765 2.3%
 
24 764 2.3%
 
25 728 2.2%
 
27 719 2.1%
 
26 704 2.1%
 
Other values (92) 25978 77.1%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length1.96700982
Min length1
Scatter

PedAgeGrp
Categorical

Distinct count20
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
30-39
4075
40-49
3877
50-59
3728
20-24
 
3137
25-29
 
2771
Other values (15)
16119
ValueCountFrequency (%) 
30-39 4075 12.1%
 
40-49 3877 11.5%
 
50-59 3728 11.1%
 
20-24 3137 9.3%
 
25-29 2771 8.2%
 
16-19 2173 6.4%
 
60-69 2158 6.4%
 
15-Nov 1873 5.6%
 
70+ 1446 4.3%
 
41-50 1225 3.6%
 
Other values (10) 7244 21.5%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length7
Mean length4.942474857
Min length3
Scatter

PedAlcDrg
Categorical

HIGH CORRELATION
Distinct count10
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
No
21576
.
7339
Yes-Alcohol, impairment suspected
 
2503
Unknown
 
1628
Yes-Alcohol and Drugs, impairment suspected
 
203
Other values (5)
 
458
ValueCountFrequency (%) 
No 21576 64.0%
 
. 7339 21.8%
 
Yes-Alcohol, impairment suspected 2503 7.4%
 
Unknown 1628 4.8%
 
Yes-Alcohol and Drugs, impairment suspected 203 0.6%
 
Yes-Alcohol, impairment detected 190 0.6%
 
Yes-Drugs, impairment suspected 157 0.5%
 
Missing 87 0.3%
 
Yes-Alcohol and Drugs, impairment detected 14 < 0.1%
 
Yes-Drugs, impairment detected 10 < 0.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length43
Mean length4.914676477
Min length1
Scatter

PedInjury
Categorical

Distinct count6
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
C: Possible Injury
13787
B: Suspected Minor Injury
11952
A: Suspected Serious Injury
 
2432
K: Killed
 
2155
O: No Injury
 
2021
ValueCountFrequency (%) 
C: Possible Injury 13787 40.9%
 
B: Suspected Minor Injury 11952 35.5%
 
A: Suspected Serious Injury 2432 7.2%
 
K: Killed 2155 6.4%
 
O: No Injury 2021 6.0%
 
Unknown Injury 1360 4.0%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length27
Mean length20.03491856
Min length9
Scatter

PedPos
Categorical

Distinct count9
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Travel Lane
15323
Non-Roadway - Parking Lot / Other
8781
Crosswalk Area
3644
Paved Shoulder / Bike Lane / Parking Lane
 
1531
Driveway / Alley
 
1132
Other values (4)
3296
ValueCountFrequency (%) 
Travel Lane 15323 45.5%
 
Non-Roadway - Parking Lot / Other 8781 26.1%
 
Crosswalk Area 3644 10.8%
 
Paved Shoulder / Bike Lane / Parking Lane 1531 4.5%
 
Driveway / Alley 1132 3.4%
 
Sidewalk / Shared Use Path / Driveway Crossing 983 2.9%
 
Unpaved Right-of-Way 834 2.5%
 
Other / Unknown 834 2.5%
 
Intersection Proper 645 1.9%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length46
Mean length20.08152609
Min length11
Scatter

PedRace
Categorical

Distinct count7
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
White
16007
Black
13492
Hispanic
 
2011
Unknown/Missing
 
1060
Other
 
401
Other values (2)
 
736
ValueCountFrequency (%) 
White 16007 47.5%
 
Black 13492 40.0%
 
Hispanic 2011 6.0%
 
Unknown/Missing 1060 3.1%
 
Other 401 1.2%
 
Asian 377 1.1%
 
Native American 359 1.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length15
Mean length5.599964399
Min length5
Scatter

PedSex
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Male
19714
Female
13254
Unknown
 
739
ValueCountFrequency (%) 
Male 19714 58.5%
 
Female 13254 39.3%
 
Unknown 739 2.2%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length7
Mean length4.852196873
Min length4
Scatter

RdCharacte
Categorical

Distinct count11
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Straight - Level
26255
Straight - Grade
 
4178
Straight - Hillcrest
 
1040
Curve - Level
 
973
Curve - Grade
 
552
Other values (6)
 
709
ValueCountFrequency (%) 
Straight - Level 26255 77.9%
 
Straight - Grade 4178 12.4%
 
Straight - Hillcrest 1040 3.1%
 
Curve - Level 973 2.9%
 
Curve - Grade 552 1.6%
 
Straight - Bottom 210 0.6%
 
Missing 178 0.5%
 
Curve - Hillcrest 127 0.4%
 
Unknown 83 0.2%
 
Other 79 0.2%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length20
Mean length15.90031744
Min length5
Scatter

RdClass
Categorical

Distinct count7
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Local Street
16604
Public Vehicular Area
8640
State Secondary Route
 
3269
US Route
 
1984
NC Route
 
1716
Other values (2)
 
1494
ValueCountFrequency (%) 
Local Street 16604 49.3%
 
Public Vehicular Area 8640 25.6%
 
State Secondary Route 3269 9.7%
 
US Route 1984 5.9%
 
NC Route 1716 5.1%
 
Private Road, Driveway 908 2.7%
 
Interstate 586 1.7%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length22
Mean length14.9753167
Min length8
Scatter

RdConditio
Categorical

Distinct count9
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Dry
28620
Wet
 
4377
Unknown
 
159
Sand, Mud, Dirt, Gravel
 
143
Ice
 
128
Other values (4)
 
280
ValueCountFrequency (%) 
Dry 28620 84.9%
 
Wet 4377 13.0%
 
Unknown 159 0.5%
 
Sand, Mud, Dirt, Gravel 143 0.4%
 
Ice 128 0.4%
 
Snow 120 0.4%
 
Water (Standing, Moving) 114 0.3%
 
Slush 30 0.1%
 
Other 16 < 0.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length24
Mean length3.181030646
Min length3
Scatter

RdConfig
Categorical

Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Two-Way, Not Divided
23953
Two-Way, Divided, Unprotected Median
 
4180
One-Way, Not Divided
 
2739
Two-Way, Divided, Positive Median Barrier
 
1775
Unknown
 
1060
ValueCountFrequency (%) 
Two-Way, Not Divided 23953 71.1%
 
Two-Way, Divided, Unprotected Median 4180 12.4%
 
One-Way, Not Divided 2739 8.1%
 
Two-Way, Divided, Positive Median Barrier 1775 5.3%
 
Unknown 1060 3.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length41
Mean length22.68119382
Min length7
Scatter

RdDefects
Categorical

Distinct count14
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
None
32962
Unknown
 
191
Road Surface Condition
 
190
Other
 
130
Work Zone
 
121
Other values (9)
 
113
ValueCountFrequency (%) 
None 32962 97.8%
 
Unknown 191 0.6%
 
Road Surface Condition 190 0.6%
 
Other 130 0.4%
 
Work Zone 121 0.4%
 
Obstruction In Roadway 26 0.1%
 
Debris 25 0.1%
 
No Shoulders 19 0.1%
 
Rut, Holes, Bumps 11 < 0.1%
 
Traffic Control Device Inoperative, Not Visible Or Missing 10 < 0.1%
 
Other values (4) 22 0.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length58
Mean length4.191414246
Min length4
Scatter

RdFeature
Categorical

Distinct count21
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
No Special Feature
20567
Driveway, Public
 
3953
Four-Way Intersection
 
2655
Missing
 
1771
T-Intersection
 
1680
Other values (16)
 
3081
ValueCountFrequency (%) 
No Special Feature 20567 61.0%
 
Driveway, Public 3953 11.7%
 
Four-Way Intersection 2655 7.9%
 
Missing 1771 5.3%
 
T-Intersection 1680 5.0%
 
Driveway, Private 1569 4.7%
 
Related To Intersection 414 1.2%
 
Other 382 1.1%
 
On or Off Ramp 243 0.7%
 
Bridge 170 0.5%
 
Other values (11) 303 0.9%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length34
Mean length17.00907823
Min length5
Scatter

RdSurface
Categorical

Distinct count10
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Smooth Asphalt
20690
Coarse Asphalt
10236
Concrete
 
1399
Gravel
 
553
Grooved Concrete
 
274
Other values (5)
 
555
ValueCountFrequency (%) 
Smooth Asphalt 20690 61.4%
 
Coarse Asphalt 10236 30.4%
 
Concrete 1399 4.2%
 
Gravel 553 1.6%
 
Grooved Concrete 274 0.8%
 
Soil 156 0.5%
 
Missing 142 0.4%
 
Other 96 0.3%
 
Sand 93 0.3%
 
Unknown 68 0.2%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length16
Mean length13.49286498
Min length4
Scatter

Region
Categorical

HIGH CORRELATION
Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Piedmont
21365
Coastal
8886
Mountains
 
3456
ValueCountFrequency (%) 
Piedmont 21365 63.4%
 
Coastal 8886 26.4%
 
Mountains 3456 10.3%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length9
Mean length7.838905865
Min length7
Scatter

RuralUrban
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Urban
25012
Rural
8695
ValueCountFrequency (%) 
Urban 25012 74.2%
 
Rural 8695 25.8%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length5
Mean length5
Min length5
Scatter

SpeedLimit
Categorical

Distinct count7
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
30 - 35 MPH
10544
40 - 45 MPH
5579
5 - 15 MPH
5544
20 - 25 MPH
4611
Unknown
3657
Other values (2)
3772
ValueCountFrequency (%) 
30 - 35 MPH 10544 31.3%
 
40 - 45 MPH 5579 16.6%
 
5 - 15 MPH 5544 16.4%
 
20 - 25 MPH 4611 13.7%
 
Unknown 3657 10.8%
 
50 - 55 MPH 3137 9.3%
 
60 - 75 MPH 635 1.9%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length12
Mean length11.10973982
Min length7
Scatter

TraffCntrl
Categorical

Distinct count15
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
No Control Present
23024
Stop And Go Signal
 
4276
Double Yellow Line, No Passing Zone
 
3280
Stop Sign
 
2153
Human Control
 
336
Other values (10)
 
638
ValueCountFrequency (%) 
No Control Present 23024 68.3%
 
Stop And Go Signal 4276 12.7%
 
Double Yellow Line, No Passing Zone 3280 9.7%
 
Stop Sign 2153 6.4%
 
Human Control 336 1.0%
 
Other 267 0.8%
 
Yield Sign 100 0.3%
 
Flashing Stop And Go Signal 85 0.3%
 
Warning Sign 49 0.1%
 
Flashing Signal Without Stop Sign 43 0.1%
 
Other values (5) 94 0.3%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length35
Mean length18.94965437
Min length5
Scatter

Weather
Categorical

Distinct count6
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size263.4 KiB
Clear
26037
Cloudy
 
4607
Rain
 
2618
Snow, Sleet, Hail, Freezing Rain/Drizzle
 
207
Fog, Smog, Smoke
 
155
ValueCountFrequency (%) 
Clear 26037 77.2%
 
Cloudy 4607 13.7%
 
Rain 2618 7.8%
 
Snow, Sleet, Hail, Freezing Rain/Drizzle 207 0.6%
 
Fog, Smog, Smoke 155 0.5%
 
Other 83 0.2%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length40
Mean length5.324531996
Min length4
Scatter

Workzone
Boolean

Distinct count3
Unique (%)< 0.1%
Missing1
Missing (%)< 0.1%
Memory size263.4 KiB
No
33391
Yes
 
315
(Missing)
 
1
ValueCountFrequency (%) 
No 33391 99.1%
 
Yes 315 0.9%
 
(Missing) 1 < 0.1%
 

Correlations

Missing values

Sample

First rows

Alcohol_PresentAmbulanceCityCountyCrashGrpCrashHourCrashLocCrashMonthCrashSevrCrashTypeCrashYearDay_of_WeekDevelopmentDrvrAgeDrvrAgeGrpDrvrAlcDrgDrvrAlcFlgDrvrInjuryDrvrRaceDrvrSexDrvrVehTypgeo_point_2dHitRunLatitudeLightCondLocalityLongitudeNumLanesNumPedsAinNumPedsBinNumPedsCinNumPedsKilNumPedsNoiNumPedsTotNumPedsUinNumUnitsPed_Intox.PedAgePedAgeGrpPedAlcDrgPedInjuryPedPosPedRacePedSexRdCharacteRdClassRdConditioRdConfigRdDefectsRdFeatureRdSurfaceRegionRuralUrbanSpeedLimitTraffCntrlWeatherWorkzone
0NoYesNone - Rural CrashHaywoodUnusual Circumstances22Non-RoadwayOctoberK: KilledDriverless Vehicle2016WednesdayResidential999UnknownMissingMissingUnknown InjuryUnknown/MissingUnknownSport Utility35.5030005611,-83.0770548701No35.503001Dark - Roadway Not LightedMixed (30% To 70% Developed)-83.0770551 lane00010102No3630-39NoK: KilledDriveway / AlleyWhiteFemaleStraight - GradePrivate Road, DrivewayDryOne-Way, Not DividedNoneDriveway, PrivateGravelMountainsRuralUnknownNo Control PresentClearNo
1NoYesKannapolisCabarrusWalking Along Roadway22Non-IntersectionSeptemberUnknown InjuryWalking Along Roadway Against Traffic - From F...2016TuesdayResidential999UnknownMissingMissingUnknown InjuryUnknown/MissingUnknownUnknown35.4425378359,-80.6259865203Yes35.442538Dark - Roadway Not LightedMixed (30% To 70% Developed)-80.6259872 lanes00000112No1716-19NoUnknown InjuryUnpaved Right-of-WayUnknown/MissingUnknownStraight - LevelLocal StreetDryTwo-Way, Not DividedNoneNo Special FeatureSmooth AsphaltPiedmontUrban30 - 35 MPHDouble Yellow Line, No Passing ZoneClearNo
2NoYesNone - Rural CrashPittOff Roadway8Non-RoadwayOctoberC: Possible InjuryOff Roadway - Parking Lot2016ThursdayInstitutional160-19NoNoO: No InjuryWhiteMaleSport Utility35.5295336958,-77.3269159495No35.529534DaylightMixed (30% To 70% Developed)-77.326916Unknown00100102No1716-19NoC: Possible InjuryNon-Roadway - Parking Lot / OtherWhiteFemaleStraight - LevelPublic Vehicular AreaDryTwo-Way, Not DividedNoneDriveway, PublicSmooth AsphaltCoastalRural5 - 15 MPHNo Control PresentClearNo
3YesYesHickoryCatawbaOff Roadway19Non-RoadwaySeptemberUnknown InjuryOff Roadway - Parking Lot2016ThursdayCommercial999UnknownMissingMissingUnknown InjuryUnknown/MissingUnknownPassenger Car35.7076545264,-81.3069425905Yes35.707655Dark - Lighted RoadwayUrban (>70% Developed)-81.306943Unknown00000112Yes5950-59Yes-Alcohol, impairment suspectedUnknown InjuryNon-Roadway - Parking Lot / OtherUnknown/MissingUnknownStraight - LevelLocal StreetDryTwo-Way, Not DividedNoneDriveway, PublicSmooth AsphaltPiedmontUrbanUnknownNo Control PresentClearNo
4NoNoMonroeUnionOff Roadway13Non-RoadwaySeptemberC: Possible InjuryOff Roadway - Parking Lot2016ThursdayResidential2925-29NoNoO: No InjuryBlackFemalePassenger Car34.9761327288,-80.5415259295No34.976133DaylightUrban (>70% Developed)-80.541526Unknown00100102No50-5NoC: Possible InjuryNon-Roadway - Parking Lot / OtherBlackMaleStraight - LevelPublic Vehicular AreaDryTwo-Way, Not DividedNoneNo Special FeatureSmooth AsphaltPiedmontUrbanUnknownNo Control PresentClearNo
5NoYesJacksonvilleOnslowOff Roadway15Non-RoadwayOctoberB: Suspected Minor InjuryOff Roadway - Other / Unknown2016TuesdayResidential5650-59UnknownUnknownUnknown InjuryBlackMaleUnknown34.7641192266,-77.4125980997Yes34.764119DaylightUrban (>70% Developed)-77.412598Unknown01000102No3730-39NoB: Suspected Minor InjuryDriveway / AlleyBlackMaleStraight - LevelLocal StreetDryOne-Way, Not DividedNoneMissingSoilCoastalUrbanUnknownNo Control PresentClearNo
6NoYesNew BernCravenCrossing Roadway—Vehicle Not Turning20Non-IntersectionOctoberK: KilledPedestrian Failed to Yield2016ThursdayCommercial8070+NoNoO: No InjuryBlackMalePickup35.1091595442,-77.0566501597No35.109160Dark - Lighted RoadwayUrban (>70% Developed)-77.0566505 lanes00010102No5950-59NoK: KilledTravel LaneBlackMaleStraight - LevelLocal StreetDryTwo-Way, Not DividedNoneNo Special FeatureSmooth AsphaltCoastalUrban30 - 35 MPHNo Control PresentClearNo
7NoNoNone - Rural CrashRutherfordBacking Vehicle14Non-RoadwayOctoberO: No InjuryBacking Vehicle - Parking Lot2016MondayCommercial5650-59NoNoO: No InjuryBlackFemalePassenger Car35.3466394517,-81.9074098604No35.346639DaylightMixed (30% To 70% Developed)-81.9074102 lanes00001102No5650-59NoO: No InjuryNon-Roadway - Parking Lot / OtherWhiteFemaleStraight - LevelPublic Vehicular AreaDryTwo-Way, Not DividedNoneDriveway, PublicCoarse AsphaltMountainsRural5 - 15 MPHNo Control PresentClearNo
8NoYesNone - Rural CrashBrunswickCrossing Roadway—Vehicle Not Turning7Non-IntersectionNovemberA: Suspected Serious InjuryPedestrian Failed to Yield2016ThursdayCommercial3130-39NoNoO: No InjuryWhiteMalePassenger Car33.9525768428,-78.0492703099No33.952577DawnUrban (>70% Developed)-78.0492703 lanes10000102No5550-59NoA: Suspected Serious InjuryTravel LaneWhiteFemaleStraight - LevelNC RouteDryTwo-Way, Not DividedNoneNo Special FeatureCoarse AsphaltCoastalRural40 - 45 MPHDouble Yellow Line, No Passing ZoneClearNo
9NoYesLumbertonRobesonDash/Dart-Out14Intersection-RelatedOctoberB: Suspected Minor InjuryDash2016SundayCommercial999UnknownMissingMissingUnknown InjuryUnknown/MissingUnknownUnknown34.6177915636,-79.0044003698Yes34.617792DaylightUrban (>70% Developed)-79.0044002 lanes01000102No30-5NoB: Suspected Minor InjuryTravel LaneNative AmericanMaleStraight - LevelLocal StreetDryTwo-Way, Not DividedNoneNo Special FeatureCoarse AsphaltCoastalUrban20 - 25 MPHNo Control PresentClearNo

Last rows

Alcohol_PresentAmbulanceCityCountyCrashGrpCrashHourCrashLocCrashMonthCrashSevrCrashTypeCrashYearDay_of_WeekDevelopmentDrvrAgeDrvrAgeGrpDrvrAlcDrgDrvrAlcFlgDrvrInjuryDrvrRaceDrvrSexDrvrVehTypgeo_point_2dHitRunLatitudeLightCondLocalityLongitudeNumLanesNumPedsAinNumPedsBinNumPedsCinNumPedsKilNumPedsNoiNumPedsTotNumPedsUinNumUnitsPed_Intox.PedAgePedAgeGrpPedAlcDrgPedInjuryPedPosPedRacePedSexRdCharacteRdClassRdConditioRdConfigRdDefectsRdFeatureRdSurfaceRegionRuralUrbanSpeedLimitTraffCntrlWeatherWorkzone
33697YesNoAshevilleBuncombeCrossing Roadway—Vehicle Not Turning20IntersectionJanuaryC: Possible InjuryMotorist Failed to Yield2010TuesdayCommercial2625-29Yes-Alcohol, impairment suspectedYesO: No InjuryWhiteMalePassenger Car35.5945014008,-82.5320757895No35.594501Dark - Lighted RoadwayUrban (>70% Developed)-82.5320765 lanes.......2No6660-69NoC: Possible InjuryCrosswalk AreaWhiteFemaleStraight - LevelUS RouteDryTwo-Way, Divided, Unprotected MedianNoneDriveway, PublicSmooth AsphaltMountainsUrban30 - 35 MPHStop And Go SignalClearNo
33698NoNoCharlotteMecklenburgUnusual Circumstances12Non-RoadwayJanuaryC: Possible InjuryVehicle-Vehicle / Object2010TuesdayCommercial7570+NoNoO: No InjuryWhiteFemaleLight Truck (Mini-Van, Panel)35.1519892954,-80.8383262696No35.151989DaylightUrban (>70% Developed)-80.838326Unknown.......3No7470+NoC: Possible InjuryNon-Roadway - Parking Lot / OtherBlackFemaleStraight - LevelPublic Vehicular AreaDryOne-Way, Not DividedNoneDriveway, PublicSmooth AsphaltPiedmontUrban20 - 25 MPHNo Control PresentClearNo
33699YesYesColumbusPolkCrossing Roadway—Vehicle Turning10IntersectionJanuaryB: Suspected Minor InjuryMotorist Right Turn on Red - Parallel Paths2010TuesdayCommercial8070+NoNoO: No InjuryWhiteMalePassenger Car35.2511260542,-82.1998301597No35.251126DaylightUrban (>70% Developed)-82.1998302 lanes.......2Yes5750-59Yes-Alcohol, impairment detectedB: Suspected Minor InjuryCrosswalk AreaWhiteFemaleStraight - LevelLocal StreetDryTwo-Way, Not DividedNoneFour-Way IntersectionSmooth AsphaltMountainsRural20 - 25 MPHStop And Go SignalClearNo
33700NoYesGrahamAlamancePedestrian in Roadway—Circumstances Unknown13Non-IntersectionJanuaryC: Possible InjuryWalking in Roadway2010MondayCommercial999UnknownMissingMissingUnknown InjuryUnknown/MissingUnknownUnknown36.0764080077,-79.4035826699Yes36.076408DaylightUrban (>70% Developed)-79.4035832 lanes.......2No2625-29NoC: Possible InjuryTravel LaneWhiteFemaleStraight - LevelLocal StreetDryTwo-Way, Not DividedNoneNo Special FeatureSmooth AsphaltPiedmontUrban30 - 35 MPHNo Control PresentClearNo
33701NoYesYadkinvilleYadkinOff Roadway12Non-RoadwayFebruaryC: Possible InjuryOff Roadway - Parking Lot2010WednesdayCommercial5350-59NoNoO: No InjuryWhiteMalePickup36.124627327,-80.6608350996No36.124627DaylightMixed (30% To 70% Developed)-80.660835Unknown.......2No7270+NoC: Possible InjuryNon-Roadway - Parking Lot / OtherWhiteFemaleStraight - LevelPublic Vehicular AreaDryTwo-Way, Not DividedNoneDriveway, PublicSmooth AsphaltMountainsRural20 - 25 MPHNo Control PresentClearNo
33702NoNoKannapolisCabarrusWalking Along Roadway14Non-IntersectionFebruaryC: Possible InjuryWalking Along Roadway Against Traffic - From F...2010MondayResidential999UnknownMissingMissingUnknown InjuryUnknown/MissingUnknownUnknown35.4975692142,-80.6479971895Yes35.497569DaylightUrban (>70% Developed)-80.6479972 lanes.......2Unknown5650-59UnknownC: Possible InjuryPaved Shoulder / Bike Lane / Parking LaneWhiteMaleStraight - GradeLocal StreetSlushTwo-Way, Not DividedNoneMissingSmooth AsphaltPiedmontUrban30 - 35 MPHNo Control PresentClearNo
33703NoNoCharlotteMecklenburgCrossing Driveway or Alley20Non-IntersectionFebruaryC: Possible InjuryMotorist Exiting Driveway or Alley2010ThursdayCommercial4040-49NoNoO: No InjuryWhiteFemalePassenger Car35.2365114641,-80.7748582202No35.236511Dark - Lighted RoadwayUrban (>70% Developed)-80.7748585 lanes.......2No6660-69NoC: Possible InjurySidewalk / Shared Use Path / Driveway CrossingBlackMaleStraight - GradeLocal StreetWetTwo-Way, Divided, Positive Median BarrierNoneNo Special FeatureCoarse AsphaltPiedmontUrban30 - 35 MPHNo Control PresentRainNo
33704NoYesDurhamDurhamCrossing Roadway—Vehicle Not Turning9Non-IntersectionFebruaryUnknown InjuryPedestrian Failed to Yield2010SundayResidential999UnknownMissingMissingUnknown InjuryUnknown/MissingUnknownPassenger Car35.9968771992,-78.8800108199Yes35.996877DaylightUrban (>70% Developed)-78.8800112 lanes.......2No2320-24NoUnknown InjuryTravel LaneBlackMaleStraight - LevelLocal StreetDryTwo-Way, Not DividedNoneNo Special FeatureCoarse AsphaltPiedmontUrban30 - 35 MPHNo Control PresentClearNo
33705NoNoCharlotteMecklenburgUnusual Circumstances15Non-RoadwayFebruaryO: No InjuryMotor Vehicle Loss of Control2010TuesdayResidential3730-39NoNoO: No InjuryOtherFemalePassenger Car35.2130009956,-80.7628115905No35.213001DaylightUrban (>70% Developed)-80.762812Unknown.......2No20-5NoO: No InjuryNon-Roadway - Parking Lot / OtherWhiteMaleStraight - GradePublic Vehicular AreaDryTwo-Way, Not DividedNoneDriveway, PublicSmooth AsphaltPiedmontUrban20 - 25 MPHNo Control PresentClearNo
33706NoNoCharlotteMecklenburgCrossing Roadway—Vehicle Turning20IntersectionFebruaryC: Possible InjuryMotorist Left Turn - Parallel Paths2010ThursdayCommercial3630-39NoNoO: No InjuryHispanicFemalePassenger Car35.2164452924,-80.8521772903No35.216445Dark - Lighted RoadwayUrban (>70% Developed)-80.8521771 lane.......3No2220-24NoC: Possible InjuryCrosswalk AreaWhiteFemaleStraight - LevelLocal StreetDryOne-Way, Not DividedNoneMissingSmooth AsphaltPiedmontUrban30 - 35 MPHStop SignClearNo